#!/bin/bash
mkdir -p ../data_filtered
for file in SaleTrain.csv RepairTrain.csv; do
  sed 's/M//' ../data/$file | sed 's/P//' | sed 's/\([0-9][0-9][0-9][0-9]\)\/\([0-9][0-9]*\)/1\/\2\/\1/g' > ../data_filtered/$file
done
